<?php
header('content-type:text/html;charset=utf-8');
require './public_function.php';
$link=dbInit();
//排序
$fields=array('e_dept','date_of_entry');
$sql_order='';
$order=isset($_GET['order']) ? $_GET['order']:'';
$sort=isset($_GET['sort']) ? $_GET['sort']:'';
if (in_array($order,$fields)){
    if($sort=='desc'){
        $sql_order="order by $order desc";
        $sort='asc';
    }else{
        $sql_order="order by $order asc";
        $sort='desc';
    }
}
//排序
//搜索
$where='';
if(isset($_GET['keyword'])){
    $keyword = $_GET['keyword'];
    $keyword = mysqli_real_escape_string($link,$keyword);
    $where = "where e_name like '%$keyword%'or e_dept like '%$keyword%'";}
//搜索
//分页
$page_size=5;
$res = mysqli_query($link,'select count(*) from  `emp_info`');
if(!$res)die();
$count=mysqli_fetch_row($res);
$count=$count[0];
$max_page=ceil($count/$page_size);
$page = isset($_GET['page']) ? intval($_GET['page']):1;
$page = $page > $max_page ? $max_page : $page;
$page = $page < 1 ? 1 : $page;
$page_html="<a href='./showlist.php?page=1'>首页</a>&nbsp;";
$page_html.="<a href='./showlist.php?page=".(($page-1)>0 ? ($page-1) : 1)."'>上一页</a>&nbsp;";
$page_html.="<a href='./showlist.php?page=".(($page+1) < $max_page ? ($page+1) : $max_page)."'>下一页</a>&nbsp;";
$page_html.="<a href='./showlist.php?page={$max_page}'>尾页</a>";
$lim=($page-1)*$page_size;
//分页

$sql="select* from `emp_info` $sql_order $where limit {$lim},{$page_size}";
$res=mysqli_query($link,$sql);
if(!$res)die();
$emp_info=array();
while($row=mysqli_fetch_assoc($res)){
    $emp_info[]=$row;
}
define('APP','itcast');
require './list_html.php';




